home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
matchconfig.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
1KB
|
26 lines
/* RCSVER $Id: matchconfig.sql,v 1.3 2000-01-11 18:18:10-06 randy Exp $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: matchconfig.sql
* Date: 08/18/1999
* memo: Randy Wood
* Description: Create the matchconfig table. This table contains
* parameters defining matching (reconciliation) behaviour.
* Changes:
************************************************************************* */
CREATE TABLE matchconfig
(
errhours NUMBER(38), /* Number of hours a cashbox is given */
/* prior to counting before it is */
/* considered missing */
tolerance NUMBER(4,2), /* Allowed tolerance before a match */
/* is marked out of balance (%) */
showall NUMBER(38), /* Display all probed data (1), or */
/* just that w/ an intent to pull */
/* or cb removal record (0) */
automatch NUMBER(38), /* 1/0: use automatching */
autopercent NUMBER(4,2) /* Percent difference to determine if */
/* a probe will be matched with a count */
);